CREATE TABLE `fa_equipment_storage` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `lock_type` varchar(50) NOT NULL COMMENT '锁类型：bluetooth_lock-蓝牙锁，concentric_lock-同心锁，chain_lock-链条锁，one_to_five_lock-一拖五锁，chair-椅子，cabinet-柜子，card_slot-卡槽，wheelchair-轮椅',
    `department_id` int(11) NOT NULL COMMENT '科室ID，关联departments表',
    `building_number` varchar(50) NOT NULL COMMENT '楼号',
    `floor` varchar(20) NOT NULL COMMENT '楼层',
    `location` varchar(255) NOT NULL COMMENT '具体位置描述',
    `device_code` varchar(100) DEFAULT NULL COMMENT '设备编码',
    `status` tinyint(1) DEFAULT '1' COMMENT '状态：1-正常，2-维修中，3-报废',
    `remark` text COMMENT '备注信息',
    `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
    `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `idx_lock_type` (`lock_type`),
    KEY `idx_department` (`department_id`),
    KEY `idx_building_floor` (`building_number`, `floor`),
    KEY `idx_status` (`status`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='设备入库表';